	
clear 
use "G:\My Drive\APSA_Rule_of_law\Data\Merging Data\data_0921_Q123Nov.dta"



gen polity_cat="autocracy" if polity2<=-6
replace polity_cat="anocracy" if polity2>=-5&polity2<=5
replace polity_cat="democracy" if polity2>=6
replace polity_cat="" if polity2==.
gen female_leader=0
replace female_leader=1 if v2exfemhos==1
replace female_leader=1 if v2exfemhog==1

gen medical_cap=doctors_perth+nurses_perth+hospbedsperth
gen coercive_cap=policecap+milpercap
 
label var BusinessRestrictions "Business Restrictions"
label var HealthMonitoring "Health Monitoring"
label var HealthResources "Health Resources"
label var MaskPolicies "Mask Policies"
label var SchoolRestrictions "School Restrictions"
label var SocialDistancing "Social Distancing"
 
sum BusinessRestrictions HealthMonitoring HealthResources MaskPolicies SchoolRestrictions SocialDistancing Capacity infcap_pca ape1 medical_cap govhealthexp_pcGDP v2x_pubcorr coercive_cap transit_stations_percent_change_ workplaces_percent_change_from_b residential_percent_change_from_ pop_density GDPpcap FDI_pcGDP Trade_pcGDP polity2  female_leader cases deaths recoveries

label var Capacity "State capacity"
label var infcap_pca "Information Capacity"
label var ape1 "Political Extraction Capacity"
label var medical_cap "Health Capacity"
label var govhealthexp_pcGDP "Gov Health Exp (\% GDP)"
label var v2x_pubcorr "Bureaucratic Corruption"
label var coercive_cap "Coercive capacity"
label var retail_and_recreation_percent_ch "Retail mobility"
label var grocery_and_pharmacy_percent_cha "Grocery mobility"
label var parks_percent_change_from_baseli "Park mobility"
label var transit_stations_percent_change_ "Transit mobility"
label var workplaces_percent_change_from_b "Workplace mobility"
label var residential_percent_change_from_ "Residential mobility"
label var pop_density "Population density"
label var GDPpcap "GDP per capita"
label var FDI_pcGDP "FDI (\% GDP)"
label var Trade_pcGDP "Trade (\% GDP)"
label var polity2 "Polity score"
label var female_leader "Female leader"
label var gini_disp "GINI"
label var cases "COVID cases"
label var deaths "COVID deaths"
label var recoveries "COVID recoveries"

gen ldeaths=log(deaths)
gen lrecoveries=log(recoveries)
gen lcases=log(cases)
label var lcases "COVID cases"
label var ldeaths "COVID deaths"
label var lrecoveries "COVID recoveries"
label var panback "Pandemic backsliding"


reg BusinessRestrictions Capacity  pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader gini_disp lcases ldeaths , ro 
eststo m1

reg BusinessRestrictions coercive_cap infcap_pca govhealthexp_pcGDP   pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader gini_disp lcases ldeaths , ro 
eststo m2

reg BusinessRestrictions coercive_cap   pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader gini_disp lcases ldeaths , ro 
eststo m3

reg BusinessRestrictions infcap_pca   pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader gini_disp lcases ldeaths , ro 
eststo m4

reg BusinessRestrictions govhealthexp_pcGDP    pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader gini_disp lcases ldeaths , ro 
eststo m5

esttab m1 m2 m3 m4 m5 using "business_restrict_Q3-Nov_nomob.tex", label se b(3) ///
order (Capacity coercive_cap infcap_pca govhealthexp_pcGDP) ///
eqlabels(none) nodiscrete booktabs replace  ///
	mtitles("(1)" "(2)" "(3)" "(4)" "(5)" "(6)") nonumber ///
	nonotes  ///
    star(* 0.10 ** 0.05 *** .01) 

	
reg HealthMonitoring Capacity  pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader gini_disp lcases ldeaths , ro 
eststo m1

reg HealthMonitoring coercive_cap infcap_pca govhealthexp_pcGDP   pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader gini_disp lcases ldeaths , ro 
eststo m2

reg HealthMonitoring coercive_cap   pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader gini_disp lcases ldeaths , ro 
eststo m3

reg HealthMonitoring infcap_pca   pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader gini_disp lcases ldeaths , ro 
eststo m4

reg HealthMonitoring govhealthexp_pcGDP    pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader gini_disp lcases ldeaths , ro 
eststo m5

esttab m1 m2 m3 m4 m5 using "health_monitor_Q3-Nov_nomob.tex", label se b(3) ///
eqlabels(none) nodiscrete booktabs replace  ///
order (Capacity coercive_cap infcap_pca govhealthexp_pcGDP) ///
	mtitles("(1)" "(2)" "(3)" "(4)" "(5)" "(6)" "(7)" "(8)") nonumber ///
	nonotes  ///
    star(* 0.10 ** 0.05 *** .01) 



reg HealthResources Capacity  pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader gini_disp lcases ldeaths , ro 
eststo m1

reg HealthResources coercive_cap infcap_pca govhealthexp_pcGDP   pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader gini_disp lcases ldeaths , ro 
eststo m2

reg HealthResources coercive_cap   pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader gini_disp lcases ldeaths , ro 
eststo m3

reg HealthResources infcap_pca   pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader gini_disp lcases ldeaths , ro 
eststo m4

reg HealthResources govhealthexp_pcGDP    pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader gini_disp lcases ldeaths , ro 
eststo m5

esttab m1 m2 m3 m4 m5 using "health_resources_Q3-Nov_nomob.tex", label se b(3) ///
eqlabels(none) nodiscrete booktabs replace  ///
order (Capacity coercive_cap infcap_pca govhealthexp_pcGDP) ///
	mtitles("(1)" "(2)" "(3)" "(4)" "(5)" "(6)") nonumber ///
	nonotes  ///
    star(* 0.10 ** 0.05 *** .01) 	
	
	 
*MaskPolicies  
reg MaskPolicies Capacity  pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader gini_disp lcases ldeaths , ro 
eststo m1

reg MaskPolicies coercive_cap infcap_pca govhealthexp_pcGDP   pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader gini_disp lcases ldeaths , ro 
eststo m2

reg MaskPolicies coercive_cap   pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader gini_disp lcases ldeaths , ro 
eststo m3

reg MaskPolicies infcap_pca   pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader gini_disp lcases ldeaths , ro 
eststo m4

reg MaskPolicies govhealthexp_pcGDP    pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader gini_disp lcases ldeaths , ro 
eststo m5

esttab m1 m2 m3 m4 m5 using "mask_policies_Q3-Nov_nomob.tex", label se b(3) ///
eqlabels(none) nodiscrete booktabs replace  ///
order (Capacity coercive_cap infcap_pca govhealthexp_pcGDP) ///
	mtitles("(1)" "(2)" "(3)" "(4)" "(5)" "(6)") nonumber ///
	nonotes  ///
    star(* 0.10 ** 0.05 *** .01) 	
	 
	 
*SchoolRestrictions 
reg SchoolRestrictions Capacity  pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader gini_disp lcases ldeaths , ro 
eststo m1

reg SchoolRestrictions coercive_cap infcap_pca govhealthexp_pcGDP   pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader gini_disp lcases ldeaths , ro 
eststo m2

reg SchoolRestrictions coercive_cap   pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader gini_disp lcases ldeaths , ro 
eststo m3

reg SchoolRestrictions infcap_pca   pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader gini_disp lcases ldeaths , ro 
eststo m4

reg SchoolRestrictions govhealthexp_pcGDP    pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader gini_disp lcases ldeaths , ro 
eststo m5

esttab m1 m2 m3 m4 m5 using "school_restrictions_Q3-Nov_nomob.tex", label se b(3) ///
eqlabels(none) nodiscrete booktabs replace  ///
order (Capacity coercive_cap infcap_pca govhealthexp_pcGDP) ///
	mtitles("(1)" "(2)" "(3)" "(4)" "(5)" "(6)") nonumber ///
	nonotes  ///
    star(* 0.10 ** 0.05 *** .01) 
	 
*SocialDistancing
reg SocialDistancing Capacity  pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader gini_disp lcases ldeaths , ro 
eststo m1

reg SocialDistancing coercive_cap infcap_pca govhealthexp_pcGDP   pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader gini_disp lcases ldeaths , ro 
eststo m2

reg SocialDistancing coercive_cap   pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader gini_disp lcases ldeaths , ro 
eststo m3

reg SocialDistancing infcap_pca   pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader gini_disp lcases ldeaths , ro 
eststo m4

reg SocialDistancing govhealthexp_pcGDP    pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader gini_disp lcases ldeaths , ro 
eststo m5

esttab m1 m2 m3 m4 m5 using "social_distancing_Q3-Nov_nomob.tex", label se b(3) ///
eqlabels(none) nodiscrete booktabs replace  ///
order (Capacity coercive_cap infcap_pca govhealthexp_pcGDP) ///
	mtitles("(1)" "(2)" "(3)" "(4)" "(5)" "(6)") nonumber ///
	nonotes  ///
    star(* 0.10 ** 0.05 *** .01) 

	
reg lcases Capacity BusinessRestrictions HealthMonitoring HealthResources MaskPolicies SchoolRestrictions SocialDistancing   pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader 
eststo m1

reg lcases coercive_cap infcap_pca govhealthexp_pcGDP BusinessRestrictions HealthMonitoring HealthResources MaskPolicies SchoolRestrictions SocialDistancing   pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader
eststo m2

reg lcases coercive_cap BusinessRestrictions HealthMonitoring HealthResources MaskPolicies SchoolRestrictions SocialDistancing   pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader
eststo m3

reg lcases infcap_pca BusinessRestrictions HealthMonitoring HealthResources MaskPolicies SchoolRestrictions SocialDistancing   pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader  
eststo m4


reg lcases govhealthexp_pcGDP BusinessRestrictions HealthMonitoring HealthResources MaskPolicies SchoolRestrictions SocialDistancing   pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader
eststo m5

esttab m1 m2 m3 m4 m5 using "cases_Q3-Nov_nomob.tex", label se b(3) ///
eqlabels(none) nodiscrete booktabs replace  ///
order (Capacity coercive_cap infcap_pca  govhealthexp_pcGDP) ///
	mtitles("(1)" "(2)" "(3)" "(4)" "(5)" "(6)") nonumber ///
	nonotes  ///
    star(* 0.10 ** 0.05 *** .01) 


	
reg ldeaths Capacity BusinessRestrictions HealthMonitoring HealthResources MaskPolicies SchoolRestrictions SocialDistancing   pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader 
eststo m1

reg ldeaths coercive_cap infcap_pca govhealthexp_pcGDP BusinessRestrictions HealthMonitoring HealthResources MaskPolicies SchoolRestrictions SocialDistancing   pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader
eststo m2

reg ldeaths coercive_cap BusinessRestrictions HealthMonitoring HealthResources MaskPolicies SchoolRestrictions SocialDistancing   pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader
eststo m3

reg ldeaths infcap_pca BusinessRestrictions HealthMonitoring HealthResources MaskPolicies SchoolRestrictions SocialDistancing   pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader  
eststo m4

reg ldeaths govhealthexp_pcGDP BusinessRestrictions HealthMonitoring HealthResources MaskPolicies SchoolRestrictions SocialDistancing   pop_density GDPpcap FDI_pcGDP Trade_pcGDP panback polity2 female_leader
eststo m5

esttab m1 m2 m3 m4 m5 using "deaths_Q3-Nov_nomob.tex", label se b(3) ///
eqlabels(none) nodiscrete booktabs replace  ///
order (Capacity coercive_cap infcap_pca govhealthexp_pcGDP) ///
	mtitles("(1)" "(2)" "(3)" "(4)" "(5)" "(6)") nonumber ///
	nonotes  ///
    star(* 0.10 ** 0.05 *** .01) 


		